﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

namespace Enterprise.Migrations
{
    public partial class addnullableEdit : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AlterColumn<string>(
                name: "VISIT_ID",
                table: "HIS_ORDERS",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<DateTime>(
                name: "VERIFY_DATA_TIME",
                table: "HIS_ORDERS",
                type: "DATETIME",
                nullable: true,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME");

            migrationBuilder.AlterColumn<DateTime>(
                name: "STOP_DATE_TIME",
                table: "HIS_ORDERS",
                type: "DATETIME",
                nullable: true,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME");

            migrationBuilder.AlterColumn<string>(
                name: "PATIENT_ID",
                table: "HIS_ORDERS",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "ORDER_TEXT",
                table: "HIS_ORDERS",
                type: "VARCHAR(800)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(800)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "ORDER_CODE",
                table: "HIS_ORDERS",
                type: "VARCHAR(200)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(200)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "ORDER_CLASS",
                table: "HIS_ORDERS",
                type: "VARCHAR(1)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(1)",
                oldNullable: true);

            migrationBuilder.AlterColumn<int>(
                name: "FREQ_INTERVAL",
                table: "HIS_ORDERS",
                type: "INT",
                nullable: true,
                oldClrType: typeof(int),
                oldType: "INT");

            migrationBuilder.AlterColumn<int>(
                name: "FREQ_COUNTER",
                table: "HIS_ORDERS",
                type: "INT",
                nullable: true,
                oldClrType: typeof(int),
                oldType: "INT");

            migrationBuilder.AlterColumn<decimal>(
                name: "DURATION",
                table: "HIS_ORDERS",
                type: "DECIMAL",
                nullable: true,
                oldClrType: typeof(decimal),
                oldType: "DECIMAL");

            migrationBuilder.AlterColumn<string>(
                name: "VISIT_ID",
                table: "HIS_OPERATION",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<DateTime>(
                name: "SCHEDULED_DATE_TIME",
                table: "HIS_OPERATION",
                type: "DATETIME",
                nullable: true,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME");

            migrationBuilder.AlterColumn<string>(
                name: "PATIENT_ID",
                table: "HIS_OPERATION",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "OPERATION_STATUS",
                table: "HIS_OPERATION",
                type: "VARCHAR(1)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(1)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "OPERATION_NAME",
                table: "HIS_OPERATION",
                type: "VARCHAR(80)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(80)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "OPERATION_ID",
                table: "HIS_OPERATION",
                type: "VARCHAR(20)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "OPERATION_CODE",
                table: "HIS_OPERATION",
                type: "VARCHAR(50)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(50)",
                oldNullable: true);

            migrationBuilder.AlterColumn<int>(
                name: "BED_NO",
                table: "HIS_OPERATION",
                type: "INT",
                nullable: true,
                oldClrType: typeof(int),
                oldType: "INT");

            migrationBuilder.AlterColumn<string>(
                name: "VISIT_ID",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<DateTime>(
                name: "REPORT_DATE_TIME",
                table: "HIS_LAB_TEST",
                type: "DATETIME",
                nullable: true,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME");

            migrationBuilder.AlterColumn<string>(
                name: "PATIENT_ID",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "LAB_TEST_NO",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(12)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(12)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "LAB_STATUS",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(1)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(1)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "LAB_ITEM_NAME",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(100)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(100)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "LAB_ITEM_CODE",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(20)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)",
                oldNullable: true);

            migrationBuilder.AlterColumn<DateTime>(
                name: "LAB_DATE_TIME",
                table: "HIS_LAB_TEST",
                type: "DATETIME",
                nullable: true,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME");

            migrationBuilder.AlterColumn<string>(
                name: "LAB_CLASS",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(20)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)",
                oldNullable: true);

            migrationBuilder.AlterColumn<int>(
                name: "BED_NO",
                table: "HIS_LAB_TEST",
                type: "INT",
                nullable: true,
                oldClrType: typeof(int),
                oldType: "INT");

            migrationBuilder.AlterColumn<string>(
                name: "RESULT",
                table: "HIS_LAB_RESULT",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "REPORT_ITEM_NAME",
                table: "HIS_LAB_RESULT",
                type: "VARCHAR(40)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(40)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "REPORT_ITEM_CODE",
                table: "HIS_LAB_RESULT",
                type: "VARCHAR(16)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(16)",
                oldNullable: true);

            migrationBuilder.AlterColumn<decimal>(
                name: "MINEGENT_LIMIT",
                table: "HIS_LAB_RESULT",
                type: "DECIMAL",
                nullable: true,
                oldClrType: typeof(decimal),
                oldType: "DECIMAL");

            migrationBuilder.AlterColumn<decimal>(
                name: "MAXEGENT_LIMIT",
                table: "HIS_LAB_RESULT",
                type: "DECIMAL",
                nullable: true,
                oldClrType: typeof(decimal),
                oldType: "DECIMAL");

            migrationBuilder.AlterColumn<string>(
                name: "LAB_TEST_NO",
                table: "HIS_LAB_RESULT",
                type: "VARCHAR(20)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)",
                oldNullable: true);

            migrationBuilder.AlterColumn<int>(
                name: "ITEM_NO",
                table: "HIS_LAB_RESULT",
                type: "INT",
                nullable: true,
                oldClrType: typeof(int),
                oldType: "INT");

            migrationBuilder.AlterColumn<string>(
                name: "REPORT_NO",
                table: "HIS_EXAM_REPORT",
                type: "VARCHAR(20)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_NO",
                table: "HIS_EXAM_REPORT",
                type: "VARCHAR(12)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(12)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "VISIT_ID",
                table: "HIS_EXAM",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<DateTime>(
                name: "REPORT_DATE_TIME",
                table: "HIS_EXAM",
                type: "DATETIME",
                nullable: true,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME");

            migrationBuilder.AlterColumn<string>(
                name: "PATIENT_ID",
                table: "HIS_EXAM",
                type: "VARCHAR(60)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_SUB_CLASS",
                table: "HIS_EXAM",
                type: "VARCHAR(30)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(30)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_STATUS",
                table: "HIS_EXAM",
                type: "VARCHAR(1)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(1)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_NO",
                table: "HIS_EXAM",
                type: "VARCHAR(12)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(12)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_ITEM_NAME",
                table: "HIS_EXAM",
                type: "VARCHAR(100)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(100)",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_ITEM_CODE",
                table: "HIS_EXAM",
                type: "VARCHAR(20)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)",
                oldNullable: true);

            migrationBuilder.AlterColumn<DateTime>(
                name: "EXAM_DATE_TIME",
                table: "HIS_EXAM",
                type: "DATETIME",
                nullable: true,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME");

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_CLASS",
                table: "HIS_EXAM",
                type: "VARCHAR(20)",
                nullable: false,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)",
                oldNullable: true);

            migrationBuilder.AlterColumn<int>(
                name: "BED_NO",
                table: "HIS_EXAM",
                type: "INT",
                nullable: true,
                oldClrType: typeof(int),
                oldType: "INT");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AlterColumn<string>(
                name: "VISIT_ID",
                table: "HIS_ORDERS",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<DateTime>(
                name: "VERIFY_DATA_TIME",
                table: "HIS_ORDERS",
                type: "DATETIME",
                nullable: false,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME",
                oldNullable: true);

            migrationBuilder.AlterColumn<DateTime>(
                name: "STOP_DATE_TIME",
                table: "HIS_ORDERS",
                type: "DATETIME",
                nullable: false,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "PATIENT_ID",
                table: "HIS_ORDERS",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<string>(
                name: "ORDER_TEXT",
                table: "HIS_ORDERS",
                type: "VARCHAR(800)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(800)");

            migrationBuilder.AlterColumn<string>(
                name: "ORDER_CODE",
                table: "HIS_ORDERS",
                type: "VARCHAR(200)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(200)");

            migrationBuilder.AlterColumn<string>(
                name: "ORDER_CLASS",
                table: "HIS_ORDERS",
                type: "VARCHAR(1)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(1)");

            migrationBuilder.AlterColumn<int>(
                name: "FREQ_INTERVAL",
                table: "HIS_ORDERS",
                type: "INT",
                nullable: false,
                oldClrType: typeof(int),
                oldType: "INT",
                oldNullable: true);

            migrationBuilder.AlterColumn<int>(
                name: "FREQ_COUNTER",
                table: "HIS_ORDERS",
                type: "INT",
                nullable: false,
                oldClrType: typeof(int),
                oldType: "INT",
                oldNullable: true);

            migrationBuilder.AlterColumn<decimal>(
                name: "DURATION",
                table: "HIS_ORDERS",
                type: "DECIMAL",
                nullable: false,
                oldClrType: typeof(decimal),
                oldType: "DECIMAL",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "VISIT_ID",
                table: "HIS_OPERATION",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<DateTime>(
                name: "SCHEDULED_DATE_TIME",
                table: "HIS_OPERATION",
                type: "DATETIME",
                nullable: false,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "PATIENT_ID",
                table: "HIS_OPERATION",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<string>(
                name: "OPERATION_STATUS",
                table: "HIS_OPERATION",
                type: "VARCHAR(1)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(1)");

            migrationBuilder.AlterColumn<string>(
                name: "OPERATION_NAME",
                table: "HIS_OPERATION",
                type: "VARCHAR(80)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(80)");

            migrationBuilder.AlterColumn<string>(
                name: "OPERATION_ID",
                table: "HIS_OPERATION",
                type: "VARCHAR(20)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)");

            migrationBuilder.AlterColumn<string>(
                name: "OPERATION_CODE",
                table: "HIS_OPERATION",
                type: "VARCHAR(50)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(50)");

            migrationBuilder.AlterColumn<int>(
                name: "BED_NO",
                table: "HIS_OPERATION",
                type: "INT",
                nullable: false,
                oldClrType: typeof(int),
                oldType: "INT",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "VISIT_ID",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<DateTime>(
                name: "REPORT_DATE_TIME",
                table: "HIS_LAB_TEST",
                type: "DATETIME",
                nullable: false,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "PATIENT_ID",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<string>(
                name: "LAB_TEST_NO",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(12)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(12)");

            migrationBuilder.AlterColumn<string>(
                name: "LAB_STATUS",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(1)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(1)");

            migrationBuilder.AlterColumn<string>(
                name: "LAB_ITEM_NAME",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(100)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(100)");

            migrationBuilder.AlterColumn<string>(
                name: "LAB_ITEM_CODE",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(20)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)");

            migrationBuilder.AlterColumn<DateTime>(
                name: "LAB_DATE_TIME",
                table: "HIS_LAB_TEST",
                type: "DATETIME",
                nullable: false,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "LAB_CLASS",
                table: "HIS_LAB_TEST",
                type: "VARCHAR(20)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)");

            migrationBuilder.AlterColumn<int>(
                name: "BED_NO",
                table: "HIS_LAB_TEST",
                type: "INT",
                nullable: false,
                oldClrType: typeof(int),
                oldType: "INT",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "RESULT",
                table: "HIS_LAB_RESULT",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<string>(
                name: "REPORT_ITEM_NAME",
                table: "HIS_LAB_RESULT",
                type: "VARCHAR(40)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(40)");

            migrationBuilder.AlterColumn<string>(
                name: "REPORT_ITEM_CODE",
                table: "HIS_LAB_RESULT",
                type: "VARCHAR(16)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(16)");

            migrationBuilder.AlterColumn<decimal>(
                name: "MINEGENT_LIMIT",
                table: "HIS_LAB_RESULT",
                type: "DECIMAL",
                nullable: false,
                oldClrType: typeof(decimal),
                oldType: "DECIMAL",
                oldNullable: true);

            migrationBuilder.AlterColumn<decimal>(
                name: "MAXEGENT_LIMIT",
                table: "HIS_LAB_RESULT",
                type: "DECIMAL",
                nullable: false,
                oldClrType: typeof(decimal),
                oldType: "DECIMAL",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "LAB_TEST_NO",
                table: "HIS_LAB_RESULT",
                type: "VARCHAR(20)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)");

            migrationBuilder.AlterColumn<int>(
                name: "ITEM_NO",
                table: "HIS_LAB_RESULT",
                type: "INT",
                nullable: false,
                oldClrType: typeof(int),
                oldType: "INT",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "REPORT_NO",
                table: "HIS_EXAM_REPORT",
                type: "VARCHAR(20)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)");

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_NO",
                table: "HIS_EXAM_REPORT",
                type: "VARCHAR(12)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(12)");

            migrationBuilder.AlterColumn<string>(
                name: "VISIT_ID",
                table: "HIS_EXAM",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<DateTime>(
                name: "REPORT_DATE_TIME",
                table: "HIS_EXAM",
                type: "DATETIME",
                nullable: false,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "PATIENT_ID",
                table: "HIS_EXAM",
                type: "VARCHAR(60)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(60)");

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_SUB_CLASS",
                table: "HIS_EXAM",
                type: "VARCHAR(30)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(30)");

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_STATUS",
                table: "HIS_EXAM",
                type: "VARCHAR(1)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(1)");

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_NO",
                table: "HIS_EXAM",
                type: "VARCHAR(12)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(12)");

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_ITEM_NAME",
                table: "HIS_EXAM",
                type: "VARCHAR(100)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(100)");

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_ITEM_CODE",
                table: "HIS_EXAM",
                type: "VARCHAR(20)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)");

            migrationBuilder.AlterColumn<DateTime>(
                name: "EXAM_DATE_TIME",
                table: "HIS_EXAM",
                type: "DATETIME",
                nullable: false,
                oldClrType: typeof(DateTime),
                oldType: "DATETIME",
                oldNullable: true);

            migrationBuilder.AlterColumn<string>(
                name: "EXAM_CLASS",
                table: "HIS_EXAM",
                type: "VARCHAR(20)",
                nullable: true,
                oldClrType: typeof(string),
                oldType: "VARCHAR(20)");

            migrationBuilder.AlterColumn<int>(
                name: "BED_NO",
                table: "HIS_EXAM",
                type: "INT",
                nullable: false,
                oldClrType: typeof(int),
                oldType: "INT",
                oldNullable: true);
        }
    }
}
